﻿  
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'RevisedSubmission_View')
BEGIN
 DROP  View RevisedSubmission_View
END
GO

CREATE	View RevisedSubmission_View
  AS
  SELECT A.*,B.EnterpriseName FROM RevisedSubmission A JOIN Enterprises_View B ON A.EnterpriseID=B.EnterpriseID
GO

